﻿<%@ Page Title="" Language="C#" MasterPageFile="~/TeacherMonther.Master" AutoEventWireup="true" CodeBehind="AllScore.aspx.cs" Inherits="李晓霞web.AllScore" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <br />
    <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="Button1" runat="server" Height="33px" OnClick="Button1_Click1" Text="全部学生信息" Width="180px" BackColor="#FFFFCC" Font-Bold="True" Font-Names="华文行楷" Font-Size="X-Large" />
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Label ID="lblInfo" runat="server"></asp:Label>
    <br />
    <br />
<br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="学号" DataSourceID="SqlDataSource2" AllowPaging="True" AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None" Visible="False" Width="714px">
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        <Columns>
            <asp:BoundField DataField="学号" HeaderText="学号" ReadOnly="True" SortExpression="学号" />
            <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
            <asp:BoundField DataField="高等数学1" HeaderText="高等数学1" SortExpression="高等数学1" />
            <asp:BoundField DataField="大学英语1" HeaderText="大学英语1" SortExpression="大学英语1" />
            <asp:BoundField DataField="C语言" HeaderText="C语言" SortExpression="C语言" />
            <asp:BoundField DataField="计算机导论" HeaderText="计算机导论" SortExpression="计算机导论" />
            <asp:BoundField DataField="大学体育" HeaderText="大学体育" SortExpression="大学体育" />
            <asp:BoundField DataField="高等数学2" HeaderText="高等数学2" SortExpression="高等数学2" />
            <asp:BoundField DataField="大学英语2" HeaderText="大学英语2" SortExpression="大学英语2" />
            <asp:BoundField DataField="静态网页" HeaderText="静态网页" SortExpression="静态网页" />
            <asp:BoundField DataField="Java" HeaderText="Java" SortExpression="Java" />
            <asp:BoundField DataField="线性代数" HeaderText="线性代数" SortExpression="线性代数" />
            <asp:BoundField DataField="大学英语3" HeaderText="大学英语3" SortExpression="大学英语3" />
            <asp:BoundField DataField="数据结构" HeaderText="数据结构" SortExpression="数据结构" />
            <asp:BoundField DataField="数据库" HeaderText="数据库" SortExpression="数据库" />
            <asp:BoundField DataField="中国近代史" HeaderText="中国近代史" SortExpression="中国近代史" />
            <asp:BoundField DataField="大学英语4" HeaderText="大学英语4" SortExpression="大学英语4" />
            <asp:BoundField DataField="教育学" HeaderText="教育学" SortExpression="教育学" />
            <asp:BoundField DataField="计算机网络" HeaderText="计算机网络" SortExpression="计算机网络" />
            <asp:BoundField DataField="离散数学" HeaderText="离散数学" SortExpression="离散数学" />
            <asp:BoundField DataField="uml" HeaderText="uml" SortExpression="uml" />
        </Columns>
        <EditRowStyle BackColor="#999999" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#E9E7E2" />
        <SortedAscendingHeaderStyle BackColor="#506C8C" />
        <SortedDescendingCellStyle BackColor="#FFFDF8" />
        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112106ConnectionString %>" SelectCommand="SELECT FirstScort.*, SecondScore.高等数学2, SecondScore.大学英语2, SecondScore.静态网页, SecondScore.Java, ThirdScore.线性代数, ThirdScore.大学英语3, ThirdScore.数据结构, ThirdScore.数据库, ThirdScore.中国近代史, FourthScore.大学英语4, FourthScore.教育学, FourthScore.计算机网络, FourthScore.离散数学, FourthScore.uml FROM FirstScort INNER JOIN SecondScore ON FirstScort.学号 = SecondScore.学号 INNER JOIN ThirdScore ON FirstScort.学号 = ThirdScore.学号 INNER JOIN FourthScore ON FirstScort.学号 = FourthScore.学号"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112106ConnectionString %>" SelectCommand="SELECT FirstScort.*, SecondScore.高等数学2, SecondScore.大学英语2, SecondScore.静态网页, SecondScore.Java, SecondScore.大学体育 AS Expr1, ThirdScore.线性代数, ThirdScore.大学英语3, ThirdScore.数据结构, ThirdScore.数据库, ThirdScore.中国近代史 FROM FirstScort INNER JOIN SecondScore ON FirstScort.学号 = SecondScore.学号 INNER JOIN ThirdScore ON FirstScort.学号 = ThirdScore.学号"></asp:SqlDataSource>
    <br />
    <br />
    <br />
&nbsp;<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<p>
</p>
</asp:Content>
